package com.wty.emp.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wty.emp.model.EmpJobWty;
import com.wty.emp.pojo.EmpWty;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author:wangtianyu
 * @Date：Created on 2020/4/20 0020 21:29
 */
public interface EmpMapperWty extends BaseMapper<EmpWty> {

    @Select("select * from wty_emp e left join wty_job j on e.jobid = j.jobid")
    List<EmpJobWty> selectEmpJob();

}
